Executive Summary 2

PROBLEMS THAT OCCURED DURING PROJECT
  1.  Wrong Data Type: DOB was showing future dates because Qlik sense was not reading the column as a date. I had to create a new column and use a MakeDate function to convert the column to a date type.
  2. Map Not Showing Some Locations: Qlik sense was not adding the leading zeros to the Zip codes so some of the Zip codes were only showing 4 digits. I had to use the script load editor make sure all the values had an equal number of digits by adding the extra zeros using a Num function.


Map Point layer using Zip or City